Note that this schedule might be altered during the quarter. Please make sure to check it every week.
Week of |
Monday |
Wednesday |
Friday |
January 1 |
|
Introduction and Overview Read: Ch. 1.1,1.2 & 1.3(optional) |
|
January 8 |
SQL Read: 3.1,3.5.1-3.5.3 4.1,4.5 - 4.8 |
SQL Project details discussed Read: 5, except 5.10 |
Project groups decided (E-mail Yana) |
January 15 |
|
SQL Homework1 Due Read: 7, except 7.2,7.4 |
Building SQL Applications Project Description |
January 22 |
SQL Read: 2 except 2.1 and ODL
discussions |
Database Schema Design Programming Assignment Due Read: 3.1-3.6 |
|
January 29 |
Database Schema Design Read: 3.5, 3.6, 3.7 and 6.1, 6.2 |
Transactions Read: 7.4 |
|
February 5 |
MidTerm |
Transactions Project Proposal Milestone 2
Due Read (vol 2): 7.2, 9.1-9.3, 9.4.1,9.4.2,9.5,9.6.3, 10.3.1, 10.3.2 |
|
February 12 |
Transactions Read: Chapter 8 |
Storage and Indexes Homework2 Due Read (vol 2): Section 3.1.3,
3.2, 3.3.1, 3.3.2, 3.4, 3.5 |
|
February 19 |
|
Storage and Indexes Section 4.3, 4.4 and 5.4 Homework3 Due |
|
February 26 |
Query Processing Read (vol 2): Section5.4.1-5.4.3 |
Query Processing Project Report Due Read (vol 2): Section2.3.3-2.3.5, 6.1-6.7, 6.8, 6.9 |
|
March 5 |
Query Optimization 15 extra min: final overview (optional) Read (vol 2): Section 7.2, 7.4, 7.5, 7.6 |
Query Optimization, XML Project due date (Interviews)
5-7 pm Homework4 Due |
Project due date (Interviews)
3-5 pm March 8th--Thursday |
March 12 |
|
|
FINAL EXAM (March 15th—THURSDAY) Low 102 2:30-4:20 pm |